<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
td
{
	border-bottom:1px solid black;
	border-right:1px solid black;
}
</style>
</head>

<body>
<?php
include("../app/connection.php");
$subjectID = $_GET["subjectID"];
$semeterID=$_GET["semeterID"];
$yearID = $_GET["yearID"];
$query = "SELECT SINHVIEN.MSSV,HOTEN,DIEMTHUCHANH,DIEMGIUAKY,DIEMCUOIKY,DIEMTRUNGBINH from KETQUA,SINHVIEN where SINHVIEN.MSSV = KETQUA.MSSV and MAMONHOC = '$subjectID' and HOCKY = $semeterID and NAM ='$yearID'";
session_start();
//$s_user="GV007";
$s_user = $_SESSION["s_user"];
?>
<table style="border-spacing:0px;border-top:1px solid black;border-left:1px solid black;width:70%">
<tr>
<td>MSSV</td><td>Họ Tên</td><td>Điểm Thực Hành</td><td>Điểm Giữa Kỳ</td><td>Điểm Cuối Kì</td><td>Điểm trung bình</td>
</tr>
<?php
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
	echo "<tr>";
	echo "<td>$row[0]</td><td>$row[1]</td><td>$row[2]</td><td>$row[3]</td><td>$row[4]</td><td>$row[5]</td>";
	echo "</tr>";
}
?>
</table>
</body>
</html>